﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

        bindData();

    }

    private void bindData()
    {

        iData.mysqlDataAcess worker = new iData.mysqlDataAcess();
        string sql = @"SELECT SCHEMA_NAME as dbname
FROM INFORMATION_SCHEMA.SCHEMATA
WHERE SCHEMA_NAME NOT IN ('information_schema', 'mysql', 'performance_schema', 'sys')"; 
        var dset = worker.Execute(sql);

        rptTblList.DataSource = dset;
        rptTblList.DataBind();

    }

}